﻿@{
    Layout = "_Layout1.cshtml";

    var db = Database.Open("Clinic");
    var query = "SELECT * FROM Doctor";

}


<article id="doctors" >
<ul>
@foreach(var item in db.Query(query)){
   <li><a href="Calendar.cshtml?ID=@item.id" > @item.Profession - @item.Name[0]. @item.Surname</a></li>    
   <br></br>
}
</ul>
</article>